SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{3c660b2acb3185b13ddd2a7425cb5d95311faa254eae942349c131b39393798b}Cala{3c660b2acb3185b13ddd2a7425cb5d95311faa254eae942349c131b39393798b}' OR prCity = 'Cala' OR prZip = 'Cala' OR prStreet LIKE '{3c660b2acb3185b13ddd2a7425cb5d95311faa254eae942349c131b39393798b}Cala{3c660b2acb3185b13ddd2a7425cb5d95311faa254eae942349c131b39393798b}' OR prCountry = 'Cala') AND (prLocation LIKE '{3c660b2acb3185b13ddd2a7425cb5d95311faa254eae942349c131b39393798b}Major{3c660b2acb3185b13ddd2a7425cb5d95311faa254eae942349c131b39393798b}' OR prCity = 'Major' OR prZip = 'Major' OR prStreet LIKE '{3c660b2acb3185b13ddd2a7425cb5d95311faa254eae942349c131b39393798b}Major{3c660b2acb3185b13ddd2a7425cb5d95311faa254eae942349c131b39393798b}' OR prCountry = 'Major') AND (prLocation LIKE '{3c660b2acb3185b13ddd2a7425cb5d95311faa254eae942349c131b39393798b}Spain{3c660b2acb3185b13ddd2a7425cb5d95311faa254eae942349c131b39393798b}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{3c660b2acb3185b13ddd2a7425cb5d95311faa254eae942349c131b39393798b}Spain{3c660b2acb3185b13ddd2a7425cb5d95311faa254eae942349c131b39393798b}' OR prCountry = 'Spain')